Dataset statistics
| Number of variables | 13 |
|---|---|
| Number of observations | 682 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 379.5 KiB |
| Average record size in memory | 569.8 B |
Variable types
| NUM | 7 |
|---|---|
| CAT | 6 |
Measure Start Date has constant value "682" | Constant |
Measure End Date has constant value "682" | Constant |
Location 1 has constant value "682" | Constant |
Avg Spending Per Episode (State) is highly correlated with Avg Spending Per Episode (Hospital) and 4 other fields | High correlation |
Avg Spending Per Episode (Hospital) is highly correlated with Avg Spending Per Episode (State) and 4 other fields | High correlation |
Avg Spending Per Episode (Nation) is highly correlated with Avg Spending Per Episode (Hospital) and 4 other fields | High correlation |
Percent of Spending (Hospital) is highly correlated with Avg Spending Per Episode (Hospital) and 4 other fields | High correlation |
Percent of Spending (State) is highly correlated with Avg Spending Per Episode (Hospital) and 4 other fields | High correlation |
Percent of Spending (Nation) is highly correlated with Avg Spending Per Episode (Hospital) and 4 other fields | High correlation |
Hospital Name is uniformly distributed | Uniform |
Avg Spending Per Episode (Hospital) has 198 (29.0%) zeros | Zeros |
Avg Spending Per Episode (State) has 124 (18.2%) zeros | Zeros |
Avg Spending Per Episode (Nation) has 124 (18.2%) zeros | Zeros |
Percent of Spending (Hospital) has 201 (29.5%) zeros | Zeros |
Percent of Spending (State) has 155 (22.7%) zeros | Zeros |
Percent of Spending (Nation) has 155 (22.7%) zeros | Zeros |
Reproduction
| Analysis started | 2020-12-12 22:08:48.184848 |
|---|---|
| Analysis finished | 2020-12-12 22:08:52.580630 |
| Duration | 4.4 seconds |
| Software version | pandas-profiling v2.9.0 |
| Download configuration | config.yaml |
| Distinct | 31 |
|---|---|
| Distinct (%) | 4.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.5 KiB |
| UTAH VALLEY REGIONAL MEDICAL CENTER | 22 |
|---|---|
| TIMPANOGOS REGIONAL HOSPITAL | 22 |
| THE ORTHOPEDIC SPECIALTY HOSPITAL | 22 |
| MOUNTAIN VIEW HOSPITAL | 22 |
| LOGAN REGIONAL HOSPITAL | 22 |
| Other values (26) |
| Value | Count | Frequency (%) | |
| UTAH VALLEY REGIONAL MEDICAL CENTER | 22 | 3.2% | |
| TIMPANOGOS REGIONAL HOSPITAL | 22 | 3.2% | |
| THE ORTHOPEDIC SPECIALTY HOSPITAL | 22 | 3.2% | |
| MOUNTAIN VIEW HOSPITAL | 22 | 3.2% | |
| LOGAN REGIONAL HOSPITAL | 22 | 3.2% | |
| OGDEN REGIONAL MEDICAL CENTER | 22 | 3.2% | |
| CASTLEVIEW HOSPITAL | 22 | 3.2% | |
| RIVERTON HOSPITAL | 22 | 3.2% | |
| DAVIS HOSPITAL AND MEDICAL CENTER | 22 | 3.2% | |
| SALT LAKE REGIONAL MEDICAL CENTER | 22 | 3.2% | |
| CACHE VALLEY HOSPITAL | 22 | 3.2% | |
| ALTA VIEW HOSPITAL | 22 | 3.2% | |
| PARK CITY MEDICAL CENTER | 22 | 3.2% | |
| UNIVERSITY HEALTH CARE/UNIV HOSPITALS AND CLINICS | 22 | 3.2% | |
| LAKEVIEW HOSPITAL | 22 | 3.2% | |
| UINTAH BASIN MEDICAL CENTER | 22 | 3.2% | |
| LDS HOSPITAL | 22 | 3.2% | |
| BEAR RIVER VALLEY HOSPITAL | 22 | 3.2% | |
| SEVIER VALLEY MEDICAL CENTER | 22 | 3.2% | |
| AMERICAN FORK HOSPITAL | 22 | 3.2% | |
| JORDAN VALLEY MEDICAL CENTER | 22 | 3.2% | |
| DIXIE REGIONAL MEDICAL CENTER | 22 | 3.2% | |
| MCKAY DEE HOSPITAL | 22 | 3.2% | |
| MOUNTAIN WEST MEDICAL CENTER | 22 | 3.2% | |
| BEAVER VALLEY HOSPITAL | 22 | 3.2% | |
| Other values (6) | 132 | 19.4% |
Frequencies of value counts
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Histogram of lengths of the category
Length
| Max length | 50 |
|---|---|
| Median length | 26 |
| Mean length | 25.80645161 |
| Min length | 12 |
Most occurring characters
| Value | Count | Frequency (%) | |
| E | 1870 | 10.6% | |
| 1760 | 10.0% | ||
| A | 1738 | 9.9% | |
| I | 1562 | 8.9% | |
| L | 1452 | 8.2% | |
| T | 1166 | 6.6% | |
| N | 902 | 5.1% | |
| O | 880 | 5.0% | |
| R | 858 | 4.9% | |
| C | 858 | 4.9% | |
| S | 748 | 4.2% | |
| H | 616 | 3.5% | |
| M | 550 | 3.1% | |
| D | 506 | 2.9% | |
| P | 506 | 2.9% | |
| V | 418 | 2.4% | |
| Y | 308 | 1.8% | |
| G | 264 | 1.5% | |
| U | 176 | 1.0% | |
| K | 132 | 0.8% | |
| W | 132 | 0.8% | |
| B | 88 | 0.5% | |
| F | 44 | 0.2% | |
| J | 22 | 0.1% | |
| X | 22 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) | |
| Uppercase Letter | 15818 | 89.9% | |
| Space Separator | 1760 | 10.0% | |
| Other Punctuation | 22 | 0.1% |
Most frequent Uppercase Letter characters
| Value | Count | Frequency (%) | |
| E | 1870 | 11.8% | |
| A | 1738 | 11.0% | |
| I | 1562 | 9.9% | |
| L | 1452 | 9.2% | |
| T | 1166 | 7.4% | |
| N | 902 | 5.7% | |
| O | 880 | 5.6% | |
| R | 858 | 5.4% | |
| C | 858 | 5.4% | |
| S | 748 | 4.7% | |
| H | 616 | 3.9% | |
| M | 550 | 3.5% | |
| D | 506 | 3.2% | |
| P | 506 | 3.2% | |
| V | 418 | 2.6% | |
| Y | 308 | 1.9% | |
| G | 264 | 1.7% | |
| U | 176 | 1.1% | |
| K | 132 | 0.8% | |
| W | 132 | 0.8% | |
| B | 88 | 0.6% | |
| F | 44 | 0.3% | |
| J | 22 | 0.1% | |
| X | 22 | 0.1% |
Most frequent Space Separator characters
| Value | Count | Frequency (%) | |
| 1760 | 100.0% |
Most frequent Other Punctuation characters
| Value | Count | Frequency (%) | |
| / | 22 | 100.0% |
Most occurring scripts
| Value | Count | Frequency (%) | |
| Latin | 15818 | 89.9% | |
| Common | 1782 | 10.1% |
Most frequent Latin characters
| Value | Count | Frequency (%) | |
| E | 1870 | 11.8% | |
| A | 1738 | 11.0% | |
| I | 1562 | 9.9% | |
| L | 1452 | 9.2% | |
| T | 1166 | 7.4% | |
| N | 902 | 5.7% | |
| O | 880 | 5.6% | |
| R | 858 | 5.4% | |
| C | 858 | 5.4% | |
| S | 748 | 4.7% | |
| H | 616 | 3.9% | |
| M | 550 | 3.5% | |
| D | 506 | 3.2% | |
| P | 506 | 3.2% | |
| V | 418 | 2.6% | |
| Y | 308 | 1.9% | |
| G | 264 | 1.7% | |
| U | 176 | 1.1% | |
| K | 132 | 0.8% | |
| W | 132 | 0.8% | |
| B | 88 | 0.6% | |
| F | 44 | 0.3% | |
| J | 22 | 0.1% | |
| X | 22 | 0.1% |
Most frequent Common characters
| Value | Count | Frequency (%) | |
| 1760 | 98.8% | ||
| / | 22 | 1.2% |
Most occurring blocks
| Value | Count | Frequency (%) | |
| ASCII | 17600 | 100.0% |
Most frequent ASCII characters
| Value | Count | Frequency (%) | |
| E | 1870 | 10.6% | |
| 1760 | 10.0% | ||
| A | 1738 | 9.9% | |
| I | 1562 | 8.9% | |
| L | 1452 | 8.2% | |
| T | 1166 | 6.6% | |
| N | 902 | 5.1% | |
| O | 880 | 5.0% | |
| R | 858 | 4.9% | |
| C | 858 | 4.9% | |
| S | 748 | 4.2% | |
| H | 616 | 3.5% | |
| M | 550 | 3.1% | |
| D | 506 | 2.9% | |
| P | 506 | 2.9% | |
| V | 418 | 2.4% | |
| Y | 308 | 1.8% | |
| G | 264 | 1.5% | |
| U | 176 | 1.0% | |
| K | 132 | 0.8% | |
| W | 132 | 0.8% | |
| B | 88 | 0.5% | |
| F | 44 | 0.2% | |
| J | 22 | 0.1% | |
| X | 22 | 0.1% |
Provider Number
Real number (ℝ≥0)
| Distinct | 31 |
|---|---|
| Distinct (%) | 4.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 460026.9677 |
|---|---|
| Minimum | 460001 |
| Maximum | 460058 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 5.5 KiB |
Quantile statistics
| Minimum | 460001 |
|---|---|
| 5-th percentile | 460003 |
| Q1 | 460010 |
| median | 460023 |
| Q3 | 460044 |
| 95-th percentile | 460057 |
| Maximum | 460058 |
| Range | 57 |
| Interquartile range (IQR) | 34 |
Descriptive statistics
| Standard deviation | 18.27579907 |
|---|---|
| Coefficient of variation (CV) | 3.972766892e-05 |
| Kurtosis | -1.377032568 |
| Mean | 460026.9677 |
| Median Absolute Deviation (MAD) | 16 |
| Skewness | 0.2351795782 |
| Sum | 313738392 |
| Variance | 334.0048316 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=31)
| Value | Count | Frequency (%) | |
| 460058 | 22 | 3.2% | |
| 460021 | 22 | 3.2% | |
| 460003 | 22 | 3.2% | |
| 460004 | 22 | 3.2% | |
| 460005 | 22 | 3.2% | |
| 460006 | 22 | 3.2% | |
| 460007 | 22 | 3.2% | |
| 460009 | 22 | 3.2% | |
| 460010 | 22 | 3.2% | |
| 460011 | 22 | 3.2% | |
| 460013 | 22 | 3.2% | |
| 460014 | 22 | 3.2% | |
| 460015 | 22 | 3.2% | |
| 460017 | 22 | 3.2% | |
| 460019 | 22 | 3.2% | |
| 460023 | 22 | 3.2% | |
| 460057 | 22 | 3.2% | |
| 460026 | 22 | 3.2% | |
| 460030 | 22 | 3.2% | |
| 460033 | 22 | 3.2% | |
| 460035 | 22 | 3.2% | |
| 460039 | 22 | 3.2% | |
| 460041 | 22 | 3.2% | |
| 460042 | 22 | 3.2% | |
| 460044 | 22 | 3.2% | |
| Other values (6) | 132 | 19.4% |
| Value | Count | Frequency (%) | |
| 460001 | 22 | 3.2% | |
| 460003 | 22 | 3.2% | |
| 460004 | 22 | 3.2% | |
| 460005 | 22 | 3.2% | |
| 460006 | 22 | 3.2% | |
| 460007 | 22 | 3.2% | |
| 460009 | 22 | 3.2% | |
| 460010 | 22 | 3.2% | |
| 460011 | 22 | 3.2% | |
| 460013 | 22 | 3.2% |
| Value | Count | Frequency (%) | |
| 460058 | 22 | 3.2% | |
| 460057 | 22 | 3.2% | |
| 460054 | 22 | 3.2% | |
| 460052 | 22 | 3.2% | |
| 460051 | 22 | 3.2% | |
| 460049 | 22 | 3.2% | |
| 460047 | 22 | 3.2% | |
| 460044 | 22 | 3.2% | |
| 460042 | 22 | 3.2% | |
| 460041 | 22 | 3.2% |
Period
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.5 KiB |
| 1 to 3 days Prior to Index Hospital Admission | |
|---|---|
| 1 through 30 days After Discharge from Index Hospital Admission | |
| During Index Hospital Admission | |
| Complete Episode |
| Value | Count | Frequency (%) | |
| 1 to 3 days Prior to Index Hospital Admission | 217 | 31.8% | |
| 1 through 30 days After Discharge from Index Hospital Admission | 217 | 31.8% | |
| During Index Hospital Admission | 217 | 31.8% | |
| Complete Episode | 31 | 4.5% |
Frequencies of value counts
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Histogram of lengths of the category
Length
| Max length | 63 |
|---|---|
| Median length | 45 |
| Mean length | 44.95454545 |
| Min length | 16 |
Most occurring characters
| Value | Count | Frequency (%) | |
| 4371 | 14.3% | ||
| s | 2635 | 8.6% | |
| i | 2635 | 8.6% | |
| o | 2449 | 8.0% | |
| d | 1767 | 5.8% | |
| t | 1550 | 5.1% | |
| r | 1519 | 5.0% | |
| n | 1519 | 5.0% | |
| a | 1302 | 4.2% | |
| e | 1178 | 3.8% | |
| m | 899 | 2.9% | |
| A | 868 | 2.8% | |
| p | 713 | 2.3% | |
| l | 682 | 2.2% | |
| h | 651 | 2.1% | |
| g | 651 | 2.1% | |
| I | 651 | 2.1% | |
| x | 651 | 2.1% | |
| H | 651 | 2.1% | |
| 1 | 434 | 1.4% | |
| u | 434 | 1.4% | |
| 3 | 434 | 1.4% | |
| y | 434 | 1.4% | |
| f | 434 | 1.4% | |
| D | 434 | 1.4% | |
| Other values (5) | 713 | 2.3% |
Most occurring categories
| Value | Count | Frequency (%) | |
| Lowercase Letter | 22320 | 72.8% | |
| Space Separator | 4371 | 14.3% | |
| Uppercase Letter | 2883 | 9.4% | |
| Decimal Number | 1085 | 3.5% |
Most frequent Decimal Number characters
| Value | Count | Frequency (%) | |
| 1 | 434 | 40.0% | |
| 3 | 434 | 40.0% | |
| 0 | 217 | 20.0% |
Most frequent Space Separator characters
| Value | Count | Frequency (%) | |
| 4371 | 100.0% |
Most frequent Lowercase Letter characters
| Value | Count | Frequency (%) | |
| s | 2635 | 11.8% | |
| i | 2635 | 11.8% | |
| o | 2449 | 11.0% | |
| d | 1767 | 7.9% | |
| t | 1550 | 6.9% | |
| r | 1519 | 6.8% | |
| n | 1519 | 6.8% | |
| a | 1302 | 5.8% | |
| e | 1178 | 5.3% | |
| m | 899 | 4.0% | |
| p | 713 | 3.2% | |
| l | 682 | 3.1% | |
| h | 651 | 2.9% | |
| g | 651 | 2.9% | |
| x | 651 | 2.9% | |
| u | 434 | 1.9% | |
| y | 434 | 1.9% | |
| f | 434 | 1.9% | |
| c | 217 | 1.0% |
Most frequent Uppercase Letter characters
| Value | Count | Frequency (%) | |
| A | 868 | 30.1% | |
| I | 651 | 22.6% | |
| H | 651 | 22.6% | |
| D | 434 | 15.1% | |
| P | 217 | 7.5% | |
| C | 31 | 1.1% | |
| E | 31 | 1.1% |
Most occurring scripts
| Value | Count | Frequency (%) | |
| Latin | 25203 | 82.2% | |
| Common | 5456 | 17.8% |
Most frequent Common characters
| Value | Count | Frequency (%) | |
| 4371 | 80.1% | ||
| 1 | 434 | 8.0% | |
| 3 | 434 | 8.0% | |
| 0 | 217 | 4.0% |
Most frequent Latin characters
| Value | Count | Frequency (%) | |
| s | 2635 | 10.5% | |
| i | 2635 | 10.5% | |
| o | 2449 | 9.7% | |
| d | 1767 | 7.0% | |
| t | 1550 | 6.2% | |
| r | 1519 | 6.0% | |
| n | 1519 | 6.0% | |
| a | 1302 | 5.2% | |
| e | 1178 | 4.7% | |
| m | 899 | 3.6% | |
| A | 868 | 3.4% | |
| p | 713 | 2.8% | |
| l | 682 | 2.7% | |
| h | 651 | 2.6% | |
| g | 651 | 2.6% | |
| I | 651 | 2.6% | |
| x | 651 | 2.6% | |
| H | 651 | 2.6% | |
| u | 434 | 1.7% | |
| y | 434 | 1.7% | |
| f | 434 | 1.7% | |
| D | 434 | 1.7% | |
| c | 217 | 0.9% | |
| P | 217 | 0.9% | |
| C | 31 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) | |
| ASCII | 30659 | 100.0% |
Most frequent ASCII characters
| Value | Count | Frequency (%) | |
| 4371 | 14.3% | ||
| s | 2635 | 8.6% | |
| i | 2635 | 8.6% | |
| o | 2449 | 8.0% | |
| d | 1767 | 5.8% | |
| t | 1550 | 5.1% | |
| r | 1519 | 5.0% | |
| n | 1519 | 5.0% | |
| a | 1302 | 4.2% | |
| e | 1178 | 3.8% | |
| m | 899 | 2.9% | |
| A | 868 | 2.8% | |
| p | 713 | 2.3% | |
| l | 682 | 2.2% | |
| h | 651 | 2.1% | |
| g | 651 | 2.1% | |
| I | 651 | 2.1% | |
| x | 651 | 2.1% | |
| H | 651 | 2.1% | |
| 1 | 434 | 1.4% | |
| u | 434 | 1.4% | |
| 3 | 434 | 1.4% | |
| y | 434 | 1.4% | |
| f | 434 | 1.4% | |
| D | 434 | 1.4% | |
| Other values (5) | 713 | 2.3% |
Claim Type
Categorical
| Distinct | 8 |
|---|---|
| Distinct (%) | 1.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.5 KiB |
| Carrier | |
|---|---|
| Hospice | |
| Durable Medical Equipment | |
| Skilled Nursing Facility | |
| Inpatient | |
| Other values (3) |
| Value | Count | Frequency (%) | |
| Carrier | 93 | 13.6% | |
| Hospice | 93 | 13.6% | |
| Durable Medical Equipment | 93 | 13.6% | |
| Skilled Nursing Facility | 93 | 13.6% | |
| Inpatient | 93 | 13.6% | |
| Outpatient | 93 | 13.6% | |
| Home Health Agency | 93 | 13.6% | |
| Total | 31 | 4.5% |
Frequencies of value counts
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Histogram of lengths of the category
Length
| Max length | 25 |
|---|---|
| Median length | 10 |
| Mean length | 13.86363636 |
| Min length | 5 |
Most occurring characters
| Value | Count | Frequency (%) | |
| e | 1023 | 10.8% | |
| i | 930 | 9.8% | |
| t | 775 | 8.2% | |
| a | 682 | 7.2% | |
| l | 589 | 6.2% | |
| n | 558 | 5.9% | |
| 558 | 5.9% | ||
| r | 465 | 4.9% | |
| p | 372 | 3.9% | |
| u | 372 | 3.9% | |
| c | 372 | 3.9% | |
| H | 279 | 3.0% | |
| o | 217 | 2.3% | |
| d | 186 | 2.0% | |
| m | 186 | 2.0% | |
| s | 186 | 2.0% | |
| g | 186 | 2.0% | |
| y | 186 | 2.0% | |
| I | 93 | 1.0% | |
| O | 93 | 1.0% | |
| D | 93 | 1.0% | |
| b | 93 | 1.0% | |
| M | 93 | 1.0% | |
| E | 93 | 1.0% | |
| q | 93 | 1.0% | |
| Other values (8) | 682 | 7.2% |
Most occurring categories
| Value | Count | Frequency (%) | |
| Lowercase Letter | 7657 | 81.0% | |
| Uppercase Letter | 1240 | 13.1% | |
| Space Separator | 558 | 5.9% |
Most frequent Uppercase Letter characters
| Value | Count | Frequency (%) | |
| H | 279 | 22.5% | |
| I | 93 | 7.5% | |
| O | 93 | 7.5% | |
| D | 93 | 7.5% | |
| M | 93 | 7.5% | |
| E | 93 | 7.5% | |
| C | 93 | 7.5% | |
| A | 93 | 7.5% | |
| S | 93 | 7.5% | |
| N | 93 | 7.5% | |
| F | 93 | 7.5% | |
| T | 31 | 2.5% |
Most frequent Lowercase Letter characters
| Value | Count | Frequency (%) | |
| e | 1023 | 13.4% | |
| i | 930 | 12.1% | |
| t | 775 | 10.1% | |
| a | 682 | 8.9% | |
| l | 589 | 7.7% | |
| n | 558 | 7.3% | |
| r | 465 | 6.1% | |
| p | 372 | 4.9% | |
| u | 372 | 4.9% | |
| c | 372 | 4.9% | |
| o | 217 | 2.8% | |
| d | 186 | 2.4% | |
| m | 186 | 2.4% | |
| s | 186 | 2.4% | |
| g | 186 | 2.4% | |
| y | 186 | 2.4% | |
| b | 93 | 1.2% | |
| q | 93 | 1.2% | |
| h | 93 | 1.2% | |
| k | 93 | 1.2% |
Most frequent Space Separator characters
| Value | Count | Frequency (%) | |
| 558 | 100.0% |
Most occurring scripts
| Value | Count | Frequency (%) | |
| Latin | 8897 | 94.1% | |
| Common | 558 | 5.9% |
Most frequent Latin characters
| Value | Count | Frequency (%) | |
| e | 1023 | 11.5% | |
| i | 930 | 10.5% | |
| t | 775 | 8.7% | |
| a | 682 | 7.7% | |
| l | 589 | 6.6% | |
| n | 558 | 6.3% | |
| r | 465 | 5.2% | |
| p | 372 | 4.2% | |
| u | 372 | 4.2% | |
| c | 372 | 4.2% | |
| H | 279 | 3.1% | |
| o | 217 | 2.4% | |
| d | 186 | 2.1% | |
| m | 186 | 2.1% | |
| s | 186 | 2.1% | |
| g | 186 | 2.1% | |
| y | 186 | 2.1% | |
| I | 93 | 1.0% | |
| O | 93 | 1.0% | |
| D | 93 | 1.0% | |
| b | 93 | 1.0% | |
| M | 93 | 1.0% | |
| E | 93 | 1.0% | |
| q | 93 | 1.0% | |
| C | 93 | 1.0% | |
| Other values (7) | 589 | 6.6% |
Most frequent Common characters
| Value | Count | Frequency (%) | |
| 558 | 100.0% |
Most occurring blocks
| Value | Count | Frequency (%) | |
| ASCII | 9455 | 100.0% |
Most frequent ASCII characters
| Value | Count | Frequency (%) | |
| e | 1023 | 10.8% | |
| i | 930 | 9.8% | |
| t | 775 | 8.2% | |
| a | 682 | 7.2% | |
| l | 589 | 6.2% | |
| n | 558 | 5.9% | |
| 558 | 5.9% | ||
| r | 465 | 4.9% | |
| p | 372 | 3.9% | |
| u | 372 | 3.9% | |
| c | 372 | 3.9% | |
| H | 279 | 3.0% | |
| o | 217 | 2.3% | |
| d | 186 | 2.0% | |
| m | 186 | 2.0% | |
| s | 186 | 2.0% | |
| g | 186 | 2.0% | |
| y | 186 | 2.0% | |
| I | 93 | 1.0% | |
| O | 93 | 1.0% | |
| D | 93 | 1.0% | |
| b | 93 | 1.0% | |
| M | 93 | 1.0% | |
| E | 93 | 1.0% | |
| q | 93 | 1.0% | |
| Other values (8) | 682 | 7.2% |
| Distinct | 363 |
|---|---|
| Distinct (%) | 53.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1653.651026 |
|---|---|
| Minimum | 0 |
| Maximum | 24579 |
| Zeros | 198 |
| Zeros (%) | 29.0% |
| Memory size | 5.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 73.5 |
| Q3 | 828.5 |
| 95-th percentile | 10905.6 |
| Maximum | 24579 |
| Range | 24579 |
| Interquartile range (IQR) | 828.5 |
Descriptive statistics
| Standard deviation | 4221.626387 |
|---|---|
| Coefficient of variation (CV) | 2.552912507 |
| Kurtosis | 11.91551389 |
| Mean | 1653.651026 |
| Median Absolute Deviation (MAD) | 73.5 |
| Skewness | 3.459083769 |
| Sum | 1127790 |
| Variance | 17822129.36 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0 | 198 | 29.0% | |
| 2 | 14 | 2.1% | |
| 21 | 8 | 1.2% | |
| 1 | 8 | 1.2% | |
| 5 | 7 | 1.0% | |
| 8 | 5 | 0.7% | |
| 15 | 5 | 0.7% | |
| 3 | 5 | 0.7% | |
| 19 | 4 | 0.6% | |
| 7 | 4 | 0.6% | |
| 22 | 4 | 0.6% | |
| 9 | 4 | 0.6% | |
| 17 | 4 | 0.6% | |
| 4 | 4 | 0.6% | |
| 16 | 4 | 0.6% | |
| 23 | 4 | 0.6% | |
| 113 | 3 | 0.4% | |
| 20 | 3 | 0.4% | |
| 414 | 3 | 0.4% | |
| 37 | 3 | 0.4% | |
| 401 | 3 | 0.4% | |
| 13 | 3 | 0.4% | |
| 14 | 3 | 0.4% | |
| 42 | 2 | 0.3% | |
| 67 | 2 | 0.3% | |
| Other values (338) | 375 | 55.0% |
| Value | Count | Frequency (%) | |
| 0 | 198 | 29.0% | |
| 1 | 8 | 1.2% | |
| 2 | 14 | 2.1% | |
| 3 | 5 | 0.7% | |
| 4 | 4 | 0.6% | |
| 5 | 7 | 1.0% | |
| 6 | 2 | 0.3% | |
| 7 | 4 | 0.6% | |
| 8 | 5 | 0.7% | |
| 9 | 4 | 0.6% |
| Value | Count | Frequency (%) | |
| 24579 | 1 | 0.1% | |
| 23727 | 1 | 0.1% | |
| 23494 | 1 | 0.1% | |
| 22868 | 1 | 0.1% | |
| 22743 | 1 | 0.1% | |
| 22199 | 1 | 0.1% | |
| 21355 | 1 | 0.1% | |
| 21280 | 1 | 0.1% | |
| 20616 | 1 | 0.1% | |
| 20204 | 1 | 0.1% |
| Distinct | 18 |
|---|---|
| Distinct (%) | 2.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1863.5 |
|---|---|
| Minimum | 0 |
| Maximum | 20499 |
| Zeros | 124 |
| Zeros (%) | 18.2% |
| Memory size | 5.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 120.5 |
| Q3 | 939 |
| 95-th percentile | 10176 |
| Maximum | 20499 |
| Range | 20499 |
| Interquartile range (IQR) | 938 |
Descriptive statistics
| Standard deviation | 4617.102107 |
|---|---|
| Coefficient of variation (CV) | 2.477650715 |
| Kurtosis | 9.673401044 |
| Mean | 1863.5 |
| Median Absolute Deviation (MAD) | 120.5 |
| Skewness | 3.230476485 |
| Sum | 1270907 |
| Variance | 21317631.87 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=18)
| Value | Count | Frequency (%) | |
| 0 | 124 | 18.2% | |
| 1 | 62 | 9.1% | |
| 20499 | 31 | 4.5% | |
| 3520 | 31 | 4.5% | |
| 192 | 31 | 4.5% | |
| 126 | 31 | 4.5% | |
| 432 | 31 | 4.5% | |
| 12 | 31 | 4.5% | |
| 4 | 31 | 4.5% | |
| 760 | 31 | 4.5% | |
| 10176 | 31 | 4.5% | |
| 115 | 31 | 4.5% | |
| 28 | 31 | 4.5% | |
| 16 | 31 | 4.5% | |
| 939 | 31 | 4.5% | |
| 1464 | 31 | 4.5% | |
| 644 | 31 | 4.5% | |
| 2068 | 31 | 4.5% |
| Value | Count | Frequency (%) | |
| 0 | 124 | 18.2% | |
| 1 | 62 | 9.1% | |
| 4 | 31 | 4.5% | |
| 12 | 31 | 4.5% | |
| 16 | 31 | 4.5% | |
| 28 | 31 | 4.5% | |
| 115 | 31 | 4.5% | |
| 126 | 31 | 4.5% | |
| 192 | 31 | 4.5% | |
| 432 | 31 | 4.5% |
| Value | Count | Frequency (%) | |
| 20499 | 31 | 4.5% | |
| 10176 | 31 | 4.5% | |
| 3520 | 31 | 4.5% | |
| 2068 | 31 | 4.5% | |
| 1464 | 31 | 4.5% | |
| 939 | 31 | 4.5% | |
| 760 | 31 | 4.5% | |
| 644 | 31 | 4.5% | |
| 432 | 31 | 4.5% | |
| 192 | 31 | 4.5% |
| Distinct | 19 |
|---|---|
| Distinct (%) | 2.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1779.818182 |
|---|---|
| Minimum | 0 |
| Maximum | 19578 |
| Zeros | 124 |
| Zeros (%) | 18.2% |
| Memory size | 5.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 2 |
| median | 110 |
| Q3 | 1078 |
| 95-th percentile | 8997 |
| Maximum | 19578 |
| Range | 19578 |
| Interquartile range (IQR) | 1076 |
Descriptive statistics
| Standard deviation | 4349.52081 |
|---|---|
| Coefficient of variation (CV) | 2.443800639 |
| Kurtosis | 10.22763729 |
| Mean | 1779.818182 |
| Median Absolute Deviation (MAD) | 110 |
| Skewness | 3.296840001 |
| Sum | 1213836 |
| Variance | 18918331.27 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=19)
| Value | Count | Frequency (%) | |
| 0 | 124 | 18.2% | |
| 1511 | 31 | 4.5% | |
| 1 | 31 | 4.5% | |
| 107 | 31 | 4.5% | |
| 488 | 31 | 4.5% | |
| 9 | 31 | 4.5% | |
| 5 | 31 | 4.5% | |
| 664 | 31 | 4.5% | |
| 119 | 31 | 4.5% | |
| 2 | 31 | 4.5% | |
| 759 | 31 | 4.5% | |
| 23 | 31 | 4.5% | |
| 13 | 31 | 4.5% | |
| 8997 | 31 | 4.5% | |
| 1078 | 31 | 4.5% | |
| 2602 | 31 | 4.5% | |
| 3087 | 31 | 4.5% | |
| 19578 | 31 | 4.5% | |
| 113 | 31 | 4.5% |
| Value | Count | Frequency (%) | |
| 0 | 124 | 18.2% | |
| 1 | 31 | 4.5% | |
| 2 | 31 | 4.5% | |
| 5 | 31 | 4.5% | |
| 9 | 31 | 4.5% | |
| 13 | 31 | 4.5% | |
| 23 | 31 | 4.5% | |
| 107 | 31 | 4.5% | |
| 113 | 31 | 4.5% | |
| 119 | 31 | 4.5% |
| Value | Count | Frequency (%) | |
| 19578 | 31 | 4.5% | |
| 8997 | 31 | 4.5% | |
| 3087 | 31 | 4.5% | |
| 2602 | 31 | 4.5% | |
| 1511 | 31 | 4.5% | |
| 1078 | 31 | 4.5% | |
| 759 | 31 | 4.5% | |
| 664 | 31 | 4.5% | |
| 488 | 31 | 4.5% | |
| 119 | 31 | 4.5% |
| Distinct | 317 |
|---|---|
| Distinct (%) | 46.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.090967742 |
|---|---|
| Minimum | 0 |
| Maximum | 100 |
| Zeros | 201 |
| Zeros (%) | 29.5% |
| Memory size | 5.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0.395 |
| Q3 | 4.7825 |
| 95-th percentile | 54.2185 |
| Maximum | 100 |
| Range | 100 |
| Interquartile range (IQR) | 4.7825 |
Descriptive statistics
| Standard deviation | 22.6226669 |
|---|---|
| Coefficient of variation (CV) | 2.488477305 |
| Kurtosis | 9.489347422 |
| Mean | 9.090967742 |
| Median Absolute Deviation (MAD) | 0.395 |
| Skewness | 3.201858997 |
| Sum | 6200.04 |
| Variance | 511.7850578 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0 | 201 | 29.5% | |
| 100 | 31 | 4.5% | |
| 0.01 | 20 | 2.9% | |
| 0.09 | 10 | 1.5% | |
| 0.03 | 9 | 1.3% | |
| 0.1 | 9 | 1.3% | |
| 0.02 | 8 | 1.2% | |
| 0.08 | 8 | 1.2% | |
| 0.05 | 7 | 1.0% | |
| 0.04 | 6 | 0.9% | |
| 0.12 | 5 | 0.7% | |
| 0.07 | 5 | 0.7% | |
| 0.14 | 5 | 0.7% | |
| 0.15 | 4 | 0.6% | |
| 0.06 | 4 | 0.6% | |
| 0.18 | 4 | 0.6% | |
| 0.3 | 4 | 0.6% | |
| 0.24 | 4 | 0.6% | |
| 0.65 | 3 | 0.4% | |
| 2.23 | 3 | 0.4% | |
| 0.28 | 3 | 0.4% | |
| 3.32 | 3 | 0.4% | |
| 3.55 | 3 | 0.4% | |
| 0.53 | 2 | 0.3% | |
| 0.19 | 2 | 0.3% | |
| Other values (292) | 319 | 46.8% |
| Value | Count | Frequency (%) | |
| 0 | 201 | 29.5% | |
| 0.01 | 20 | 2.9% | |
| 0.02 | 8 | 1.2% | |
| 0.03 | 9 | 1.3% | |
| 0.04 | 6 | 0.9% | |
| 0.05 | 7 | 1.0% | |
| 0.06 | 4 | 0.6% | |
| 0.07 | 5 | 0.7% | |
| 0.08 | 8 | 1.2% | |
| 0.09 | 10 | 1.5% |
| Value | Count | Frequency (%) | |
| 100 | 31 | 4.5% | |
| 61.77 | 1 | 0.1% | |
| 56.72 | 1 | 0.1% | |
| 54.45 | 1 | 0.1% | |
| 54.26 | 1 | 0.1% | |
| 53.43 | 1 | 0.1% | |
| 53.2 | 1 | 0.1% | |
| 52.94 | 1 | 0.1% | |
| 51.99 | 1 | 0.1% | |
| 51.88 | 1 | 0.1% |
| Distinct | 18 |
|---|---|
| Distinct (%) | 2.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.090909091 |
|---|---|
| Minimum | 0 |
| Maximum | 100 |
| Zeros | 155 |
| Zeros (%) | 22.7% |
| Memory size | 5.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0.01 |
| median | 0.585 |
| Q3 | 4.58 |
| 95-th percentile | 49.64 |
| Maximum | 100 |
| Range | 100 |
| Interquartile range (IQR) | 4.57 |
Descriptive statistics
| Standard deviation | 22.52328133 |
|---|---|
| Coefficient of variation (CV) | 2.477560946 |
| Kurtosis | 9.673801185 |
| Mean | 9.090909091 |
| Median Absolute Deviation (MAD) | 0.585 |
| Skewness | 3.230538445 |
| Sum | 6200 |
| Variance | 507.2982018 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=18)
| Value | Count | Frequency (%) | |
| 0 | 155 | 22.7% | |
| 0.06 | 31 | 4.5% | |
| 100 | 31 | 4.5% | |
| 0.14 | 31 | 4.5% | |
| 0.94 | 31 | 4.5% | |
| 17.17 | 31 | 4.5% | |
| 10.09 | 31 | 4.5% | |
| 4.58 | 31 | 4.5% | |
| 0.61 | 31 | 4.5% | |
| 0.01 | 31 | 4.5% | |
| 7.14 | 31 | 4.5% | |
| 49.64 | 31 | 4.5% | |
| 3.71 | 31 | 4.5% | |
| 0.08 | 31 | 4.5% | |
| 0.56 | 31 | 4.5% | |
| 2.11 | 31 | 4.5% | |
| 3.14 | 31 | 4.5% | |
| 0.02 | 31 | 4.5% |
| Value | Count | Frequency (%) | |
| 0 | 155 | 22.7% | |
| 0.01 | 31 | 4.5% | |
| 0.02 | 31 | 4.5% | |
| 0.06 | 31 | 4.5% | |
| 0.08 | 31 | 4.5% | |
| 0.14 | 31 | 4.5% | |
| 0.56 | 31 | 4.5% | |
| 0.61 | 31 | 4.5% | |
| 0.94 | 31 | 4.5% | |
| 2.11 | 31 | 4.5% |
| Value | Count | Frequency (%) | |
| 100 | 31 | 4.5% | |
| 49.64 | 31 | 4.5% | |
| 17.17 | 31 | 4.5% | |
| 10.09 | 31 | 4.5% | |
| 7.14 | 31 | 4.5% | |
| 4.58 | 31 | 4.5% | |
| 3.71 | 31 | 4.5% | |
| 3.14 | 31 | 4.5% | |
| 2.11 | 31 | 4.5% | |
| 0.94 | 31 | 4.5% |
| Distinct | 18 |
|---|---|
| Distinct (%) | 2.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.091818182 |
|---|---|
| Minimum | 0 |
| Maximum | 100 |
| Zeros | 155 |
| Zeros (%) | 22.7% |
| Memory size | 5.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0.01 |
| median | 0.565 |
| Q3 | 5.51 |
| 95-th percentile | 45.96 |
| Maximum | 100 |
| Range | 100 |
| Interquartile range (IQR) | 5.5 |
Descriptive statistics
| Standard deviation | 22.21665372 |
|---|---|
| Coefficient of variation (CV) | 2.44358755 |
| Kurtosis | 10.22661658 |
| Mean | 9.091818182 |
| Median Absolute Deviation (MAD) | 0.565 |
| Skewness | 3.296688961 |
| Sum | 6200.62 |
| Variance | 493.5797024 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=18)
| Value | Count | Frequency (%) | |
| 0 | 155 | 22.7% | |
| 45.96 | 31 | 4.5% | |
| 100 | 31 | 4.5% | |
| 13.29 | 31 | 4.5% | |
| 2.49 | 31 | 4.5% | |
| 0.61 | 31 | 4.5% | |
| 0.02 | 31 | 4.5% | |
| 0.58 | 31 | 4.5% | |
| 0.55 | 31 | 4.5% | |
| 5.51 | 31 | 4.5% | |
| 3.88 | 31 | 4.5% | |
| 0.07 | 31 | 4.5% | |
| 7.72 | 31 | 4.5% | |
| 3.39 | 31 | 4.5% | |
| 0.12 | 31 | 4.5% | |
| 15.77 | 31 | 4.5% | |
| 0.05 | 31 | 4.5% | |
| 0.01 | 31 | 4.5% |
| Value | Count | Frequency (%) | |
| 0 | 155 | 22.7% | |
| 0.01 | 31 | 4.5% | |
| 0.02 | 31 | 4.5% | |
| 0.05 | 31 | 4.5% | |
| 0.07 | 31 | 4.5% | |
| 0.12 | 31 | 4.5% | |
| 0.55 | 31 | 4.5% | |
| 0.58 | 31 | 4.5% | |
| 0.61 | 31 | 4.5% | |
| 2.49 | 31 | 4.5% |
| Value | Count | Frequency (%) | |
| 100 | 31 | 4.5% | |
| 45.96 | 31 | 4.5% | |
| 15.77 | 31 | 4.5% | |
| 13.29 | 31 | 4.5% | |
| 7.72 | 31 | 4.5% | |
| 5.51 | 31 | 4.5% | |
| 3.88 | 31 | 4.5% | |
| 3.39 | 31 | 4.5% | |
| 2.49 | 31 | 4.5% | |
| 0.61 | 31 | 4.5% |
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.5 KiB |
| 01/01/2013 12:00:00 AM |
|---|
| Value | Count | Frequency (%) | |
| 01/01/2013 12:00:00 AM | 682 | 100.0% |
Frequencies of value counts
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Histogram of lengths of the category
Length
| Max length | 22 |
|---|---|
| Median length | 22 |
| Mean length | 22 |
| Min length | 22 |
Most occurring characters
| Value | Count | Frequency (%) | |
| 0 | 4774 | 31.8% | |
| 1 | 2728 | 18.2% | |
| / | 1364 | 9.1% | |
| 2 | 1364 | 9.1% | |
| 1364 | 9.1% | ||
| : | 1364 | 9.1% | |
| 3 | 682 | 4.5% | |
| A | 682 | 4.5% | |
| M | 682 | 4.5% |
Most occurring categories
| Value | Count | Frequency (%) | |
| Decimal Number | 9548 | 63.6% | |
| Other Punctuation | 2728 | 18.2% | |
| Space Separator | 1364 | 9.1% | |
| Uppercase Letter | 1364 | 9.1% |
Most frequent Decimal Number characters
| Value | Count | Frequency (%) | |
| 0 | 4774 | 50.0% | |
| 1 | 2728 | 28.6% | |
| 2 | 1364 | 14.3% | |
| 3 | 682 | 7.1% |
Most frequent Other Punctuation characters
| Value | Count | Frequency (%) | |
| / | 1364 | 50.0% | |
| : | 1364 | 50.0% |
Most frequent Space Separator characters
| Value | Count | Frequency (%) | |
| 1364 | 100.0% |
Most frequent Uppercase Letter characters
| Value | Count | Frequency (%) | |
| A | 682 | 50.0% | |
| M | 682 | 50.0% |
Most occurring scripts
| Value | Count | Frequency (%) | |
| Common | 13640 | 90.9% | |
| Latin | 1364 | 9.1% |
Most frequent Common characters
| Value | Count | Frequency (%) | |
| 0 | 4774 | 35.0% | |
| 1 | 2728 | 20.0% | |
| / | 1364 | 10.0% | |
| 2 | 1364 | 10.0% | |
| 1364 | 10.0% | ||
| : | 1364 | 10.0% | |
| 3 | 682 | 5.0% |
Most frequent Latin characters
| Value | Count | Frequency (%) | |
| A | 682 | 50.0% | |
| M | 682 | 50.0% |
Most occurring blocks
| Value | Count | Frequency (%) | |
| ASCII | 15004 | 100.0% |
Most frequent ASCII characters
| Value | Count | Frequency (%) | |
| 0 | 4774 | 31.8% | |
| 1 | 2728 | 18.2% | |
| / | 1364 | 9.1% | |
| 2 | 1364 | 9.1% | |
| 1364 | 9.1% | ||
| : | 1364 | 9.1% | |
| 3 | 682 | 4.5% | |
| A | 682 | 4.5% | |
| M | 682 | 4.5% |
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.5 KiB |
| 12/31/2013 12:00:00 AM |
|---|
| Value | Count | Frequency (%) | |
| 12/31/2013 12:00:00 AM | 682 | 100.0% |
Frequencies of value counts
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Histogram of lengths of the category
Length
| Max length | 22 |
|---|---|
| Median length | 22 |
| Mean length | 22 |
| Min length | 22 |
Most occurring characters
| Value | Count | Frequency (%) | |
| 0 | 3410 | 22.7% | |
| 1 | 2728 | 18.2% | |
| 2 | 2046 | 13.6% | |
| / | 1364 | 9.1% | |
| 3 | 1364 | 9.1% | |
| 1364 | 9.1% | ||
| : | 1364 | 9.1% | |
| A | 682 | 4.5% | |
| M | 682 | 4.5% |
Most occurring categories
| Value | Count | Frequency (%) | |
| Decimal Number | 9548 | 63.6% | |
| Other Punctuation | 2728 | 18.2% | |
| Space Separator | 1364 | 9.1% | |
| Uppercase Letter | 1364 | 9.1% |
Most frequent Decimal Number characters
| Value | Count | Frequency (%) | |
| 0 | 3410 | 35.7% | |
| 1 | 2728 | 28.6% | |
| 2 | 2046 | 21.4% | |
| 3 | 1364 | 14.3% |
Most frequent Other Punctuation characters
| Value | Count | Frequency (%) | |
| / | 1364 | 50.0% | |
| : | 1364 | 50.0% |
Most frequent Space Separator characters
| Value | Count | Frequency (%) | |
| 1364 | 100.0% |
Most frequent Uppercase Letter characters
| Value | Count | Frequency (%) | |
| A | 682 | 50.0% | |
| M | 682 | 50.0% |
Most occurring scripts
| Value | Count | Frequency (%) | |
| Common | 13640 | 90.9% | |
| Latin | 1364 | 9.1% |
Most frequent Common characters
| Value | Count | Frequency (%) | |
| 0 | 3410 | 25.0% | |
| 1 | 2728 | 20.0% | |
| 2 | 2046 | 15.0% | |
| / | 1364 | 10.0% | |
| 3 | 1364 | 10.0% | |
| 1364 | 10.0% | ||
| : | 1364 | 10.0% |
Most frequent Latin characters
| Value | Count | Frequency (%) | |
| A | 682 | 50.0% | |
| M | 682 | 50.0% |
Most occurring blocks
| Value | Count | Frequency (%) | |
| ASCII | 15004 | 100.0% |
Most frequent ASCII characters
| Value | Count | Frequency (%) | |
| 0 | 3410 | 22.7% | |
| 1 | 2728 | 18.2% | |
| 2 | 2046 | 13.6% | |
| / | 1364 | 9.1% | |
| 3 | 1364 | 9.1% | |
| 1364 | 9.1% | ||
| : | 1364 | 9.1% | |
| A | 682 | 4.5% | |
| M | 682 | 4.5% |
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.5 KiB |
| UT (39.36070123200005, -111.58712831499997) |
|---|
| Value | Count | Frequency (%) | |
| UT (39.36070123200005, -111.58712831499997) | 682 | 100.0% |
Frequencies of value counts
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Histogram of lengths of the category
Length
| Max length | 43 |
|---|---|
| Median length | 43 |
| Mean length | 43 |
| Min length | 43 |
Most occurring characters
| Value | Count | Frequency (%) | |
| 0 | 4092 | 14.0% | |
| 1 | 4092 | 14.0% | |
| 9 | 3410 | 11.6% | |
| 3 | 2728 | 9.3% | |
| 7 | 2046 | 7.0% | |
| 2 | 2046 | 7.0% | |
| . | 1364 | 4.7% | |
| 5 | 1364 | 4.7% | |
| 8 | 1364 | 4.7% | |
| U | 682 | 2.3% | |
| T | 682 | 2.3% | |
| 682 | 2.3% | ||
| ( | 682 | 2.3% | |
| 6 | 682 | 2.3% | |
| , | 682 | 2.3% | |
| 682 | 2.3% | ||
| - | 682 | 2.3% | |
| 4 | 682 | 2.3% | |
| ) | 682 | 2.3% |
Most occurring categories
| Value | Count | Frequency (%) | |
| Decimal Number | 22506 | 76.7% | |
| Other Punctuation | 2046 | 7.0% | |
| Uppercase Letter | 1364 | 4.7% | |
| Control | 682 | 2.3% | |
| Open Punctuation | 682 | 2.3% | |
| Space Separator | 682 | 2.3% | |
| Dash Punctuation | 682 | 2.3% | |
| Close Punctuation | 682 | 2.3% |
Most frequent Uppercase Letter characters
| Value | Count | Frequency (%) | |
| U | 682 | 50.0% | |
| T | 682 | 50.0% |
Most frequent Control characters
| Value | Count | Frequency (%) | |
| 682 | 100.0% |
Most frequent Open Punctuation characters
| Value | Count | Frequency (%) | |
| ( | 682 | 100.0% |
Most frequent Decimal Number characters
| Value | Count | Frequency (%) | |
| 0 | 4092 | 18.2% | |
| 1 | 4092 | 18.2% | |
| 9 | 3410 | 15.2% | |
| 3 | 2728 | 12.1% | |
| 7 | 2046 | 9.1% | |
| 2 | 2046 | 9.1% | |
| 5 | 1364 | 6.1% | |
| 8 | 1364 | 6.1% | |
| 6 | 682 | 3.0% | |
| 4 | 682 | 3.0% |
Most frequent Other Punctuation characters
| Value | Count | Frequency (%) | |
| . | 1364 | 66.7% | |
| , | 682 | 33.3% |
Most frequent Space Separator characters
| Value | Count | Frequency (%) | |
| 682 | 100.0% |
Most frequent Dash Punctuation characters
| Value | Count | Frequency (%) | |
| - | 682 | 100.0% |
Most frequent Close Punctuation characters
| Value | Count | Frequency (%) | |
| ) | 682 | 100.0% |
Most occurring scripts
| Value | Count | Frequency (%) | |
| Common | 27962 | 95.3% | |
| Latin | 1364 | 4.7% |
Most frequent Latin characters
| Value | Count | Frequency (%) | |
| U | 682 | 50.0% | |
| T | 682 | 50.0% |
Most frequent Common characters
| Value | Count | Frequency (%) | |
| 0 | 4092 | 14.6% | |
| 1 | 4092 | 14.6% | |
| 9 | 3410 | 12.2% | |
| 3 | 2728 | 9.8% | |
| 7 | 2046 | 7.3% | |
| 2 | 2046 | 7.3% | |
| . | 1364 | 4.9% | |
| 5 | 1364 | 4.9% | |
| 8 | 1364 | 4.9% | |
| 682 | 2.4% | ||
| ( | 682 | 2.4% | |
| 6 | 682 | 2.4% | |
| , | 682 | 2.4% | |
| 682 | 2.4% | ||
| - | 682 | 2.4% | |
| 4 | 682 | 2.4% | |
| ) | 682 | 2.4% |
Most occurring blocks
| Value | Count | Frequency (%) | |
| ASCII | 29326 | 100.0% |
Most frequent ASCII characters
| Value | Count | Frequency (%) | |
| 0 | 4092 | 14.0% | |
| 1 | 4092 | 14.0% | |
| 9 | 3410 | 11.6% | |
| 3 | 2728 | 9.3% | |
| 7 | 2046 | 7.0% | |
| 2 | 2046 | 7.0% | |
| . | 1364 | 4.7% | |
| 5 | 1364 | 4.7% | |
| 8 | 1364 | 4.7% | |
| U | 682 | 2.3% | |
| T | 682 | 2.3% | |
| 682 | 2.3% | ||
| ( | 682 | 2.3% | |
| 6 | 682 | 2.3% | |
| , | 682 | 2.3% | |
| 682 | 2.3% | ||
| - | 682 | 2.3% | |
| 4 | 682 | 2.3% | |
| ) | 682 | 2.3% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| Hospital Name | Provider Number | Period | Claim Type | Avg Spending Per Episode (Hospital) | Avg Spending Per Episode (State) | Avg Spending Per Episode (Nation) | Percent of Spending (Hospital) | Percent of Spending (State) | Percent of Spending (Nation) | Measure Start Date | Measure End Date | Location 1 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | GARFIELD MEMORIAL HOSPITAL | 460033 | 1 through 30 days After Discharge from Index Hospital Admission | Inpatient | 968.0 | 2068.0 | 2602.0 | 8.86 | 10.09 | 13.29 | 01/01/2013 12:00:00 AM | 12/31/2013 12:00:00 AM | UT\n(39.36070123200005, -111.58712831499997) |
| 1 | JORDAN VALLEY MEDICAL CENTER | 460051 | 1 to 3 days Prior to Index Hospital Admission | Outpatient | 35.0 | 192.0 | 113.0 | 0.18 | 0.94 | 0.58 | 01/01/2013 12:00:00 AM | 12/31/2013 12:00:00 AM | UT\n(39.36070123200005, -111.58712831499997) |
| 2 | LOGAN REGIONAL HOSPITAL | 460015 | 1 through 30 days After Discharge from Index Hospital Admission | Durable Medical Equipment | 105.0 | 126.0 | 107.0 | 0.62 | 0.61 | 0.55 | 01/01/2013 12:00:00 AM | 12/31/2013 12:00:00 AM | UT\n(39.36070123200005, -111.58712831499997) |
| 3 | ST MARKS HOSPITAL | 460047 | During Index Hospital Admission | Hospice | 0.0 | 0.0 | 0.0 | 0.00 | 0.00 | 0.00 | 01/01/2013 12:00:00 AM | 12/31/2013 12:00:00 AM | UT\n(39.36070123200005, -111.58712831499997) |
| 4 | OGDEN REGIONAL MEDICAL CENTER | 460005 | 1 to 3 days Prior to Index Hospital Admission | Carrier | 498.0 | 432.0 | 488.0 | 2.42 | 2.11 | 2.49 | 01/01/2013 12:00:00 AM | 12/31/2013 12:00:00 AM | UT\n(39.36070123200005, -111.58712831499997) |
| 5 | VALLEY VIEW MEDICAL CENTER | 460007 | 1 through 30 days After Discharge from Index Hospital Admission | Home Health Agency | 793.0 | 939.0 | 759.0 | 4.97 | 4.58 | 3.88 | 01/01/2013 12:00:00 AM | 12/31/2013 12:00:00 AM | UT\n(39.36070123200005, -111.58712831499997) |
| 6 | JORDAN VALLEY MEDICAL CENTER | 460051 | 1 to 3 days Prior to Index Hospital Admission | Durable Medical Equipment | 19.0 | 12.0 | 9.0 | 0.10 | 0.06 | 0.05 | 01/01/2013 12:00:00 AM | 12/31/2013 12:00:00 AM | UT\n(39.36070123200005, -111.58712831499997) |
| 7 | LDS HOSPITAL | 460006 | During Index Hospital Admission | Home Health Agency | 0.0 | 0.0 | 0.0 | 0.00 | 0.00 | 0.00 | 01/01/2013 12:00:00 AM | 12/31/2013 12:00:00 AM | UT\n(39.36070123200005, -111.58712831499997) |
| 8 | LOGAN REGIONAL HOSPITAL | 460015 | During Index Hospital Admission | Hospice | 0.0 | 0.0 | 0.0 | 0.00 | 0.00 | 0.00 | 01/01/2013 12:00:00 AM | 12/31/2013 12:00:00 AM | UT\n(39.36070123200005, -111.58712831499997) |
| 9 | SEVIER VALLEY MEDICAL CENTER | 460026 | During Index Hospital Admission | Carrier | 815.0 | 1464.0 | 1511.0 | 4.60 | 7.14 | 7.72 | 01/01/2013 12:00:00 AM | 12/31/2013 12:00:00 AM | UT\n(39.36070123200005, -111.58712831499997) |
Last rows
| Hospital Name | Provider Number | Period | Claim Type | Avg Spending Per Episode (Hospital) | Avg Spending Per Episode (State) | Avg Spending Per Episode (Nation) | Percent of Spending (Hospital) | Percent of Spending (State) | Percent of Spending (Nation) | Measure Start Date | Measure End Date | Location 1 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 672 | GARFIELD MEMORIAL HOSPITAL | 460033 | Complete Episode | Total | 10916.0 | 20499.0 | 19578.0 | 100.00 | 100.00 | 100.00 | 01/01/2013 12:00:00 AM | 12/31/2013 12:00:00 AM | UT\n(39.36070123200005, -111.58712831499997) |
| 673 | INTERMOUNTAIN MEDICAL CENTER | 460010 | During Index Hospital Admission | Inpatient | 10502.0 | 10176.0 | 8997.0 | 49.35 | 49.64 | 45.96 | 01/01/2013 12:00:00 AM | 12/31/2013 12:00:00 AM | UT\n(39.36070123200005, -111.58712831499997) |
| 674 | GARFIELD MEMORIAL HOSPITAL | 460033 | 1 to 3 days Prior to Index Hospital Admission | Carrier | 205.0 | 432.0 | 488.0 | 1.87 | 2.11 | 2.49 | 01/01/2013 12:00:00 AM | 12/31/2013 12:00:00 AM | UT\n(39.36070123200005, -111.58712831499997) |
| 675 | JORDAN VALLEY MEDICAL CENTER | 460051 | Complete Episode | Total | 19266.0 | 20499.0 | 19578.0 | 100.00 | 100.00 | 100.00 | 01/01/2013 12:00:00 AM | 12/31/2013 12:00:00 AM | UT\n(39.36070123200005, -111.58712831499997) |
| 676 | INTERMOUNTAIN MEDICAL CENTER | 460010 | 1 through 30 days After Discharge from Index Hospital Admission | Outpatient | 713.0 | 644.0 | 664.0 | 3.35 | 3.14 | 3.39 | 01/01/2013 12:00:00 AM | 12/31/2013 12:00:00 AM | UT\n(39.36070123200005, -111.58712831499997) |
| 677 | OGDEN REGIONAL MEDICAL CENTER | 460005 | 1 to 3 days Prior to Index Hospital Admission | Home Health Agency | 9.0 | 16.0 | 13.0 | 0.05 | 0.08 | 0.07 | 01/01/2013 12:00:00 AM | 12/31/2013 12:00:00 AM | UT\n(39.36070123200005, -111.58712831499997) |
| 678 | OGDEN REGIONAL MEDICAL CENTER | 460005 | 1 to 3 days Prior to Index Hospital Admission | Durable Medical Equipment | 5.0 | 12.0 | 9.0 | 0.02 | 0.06 | 0.05 | 01/01/2013 12:00:00 AM | 12/31/2013 12:00:00 AM | UT\n(39.36070123200005, -111.58712831499997) |
| 679 | LAKEVIEW HOSPITAL | 460042 | 1 through 30 days After Discharge from Index Hospital Admission | Durable Medical Equipment | 37.0 | 126.0 | 107.0 | 0.19 | 0.61 | 0.55 | 01/01/2013 12:00:00 AM | 12/31/2013 12:00:00 AM | UT\n(39.36070123200005, -111.58712831499997) |
| 680 | BEAR RIVER VALLEY HOSPITAL | 460039 | During Index Hospital Admission | Skilled Nursing Facility | 0.0 | 0.0 | 0.0 | 0.00 | 0.00 | 0.00 | 01/01/2013 12:00:00 AM | 12/31/2013 12:00:00 AM | UT\n(39.36070123200005, -111.58712831499997) |
| 681 | MOUNTAIN WEST MEDICAL CENTER | 460014 | 1 through 30 days After Discharge from Index Hospital Admission | Hospice | 52.0 | 115.0 | 119.0 | 0.35 | 0.56 | 0.61 | 01/01/2013 12:00:00 AM | 12/31/2013 12:00:00 AM | UT\n(39.36070123200005, -111.58712831499997) |